Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	49894
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.3 MiB
Average record size in memory	112.0 B

Variable types

Numeric	9
DateTime	2
Categorical	2
Boolean	1

Alerts

`staff_id` is highly overall correlated with `sales_outlet_id`	High correlation
`customer_id` is highly overall correlated with `sales_outlet_id`	High correlation
`line_item_id` is highly overall correlated with `product_id`	High correlation
`product_id` is highly overall correlated with `line_item_id`	High correlation
`quantity` is highly overall correlated with `line_item_amount`	High correlation
`line_item_amount` is highly overall correlated with `quantity` and 1 other fields	High correlation
`unit_price` is highly overall correlated with `line_item_amount`	High correlation
`sales_outlet_id` is highly overall correlated with `staff_id` and 1 other fields	High correlation
`promo_item_yn` is highly imbalanced (92.0%)	Imbalance
`line_item_amount` is highly skewed (γ1 = 42.89584499)	Skewed
`customer_id` has 25033 (50.2%) zeros	Zeros

Reproduction

Analysis started	2023-08-02 23:57:27.386211
Analysis finished	2023-08-02 23:58:13.176663
Duration	45.79 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

transaction_id
Real number (ℝ)

Distinct	4203
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	869.05606

Minimum	1
Maximum	4203
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	223
median	481
Q3	1401
95-th percentile	2487.35
Maximum	4203
Range	4202
Interquartile range (IQR)	1178

Descriptive statistics

Standard deviation	857.86315
Coefficient of variation (CV)	0.98712061
Kurtosis	1.3597398
Mean	869.05606
Median Absolute Deviation (MAD)	372
Skewness	1.3185563
Sum	43360683
Variance	735929.18
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
97	67	0.1%
49	66	0.1%
45	65	0.1%
274	65	0.1%
252	64	0.1%
319	64	0.1%
179	64	0.1%
36	63	0.1%
177	63	0.1%
324	63	0.1%
Other values (4193)	49250	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	57	0.1%
2	54	0.1%
3	59	0.1%
4	54	0.1%
5	62	0.1%
6	56	0.1%
7	55	0.1%
8	56	0.1%
9	59	0.1%
10	57	0.1%

Value	Count	Frequency (%)
4203	1	< 0.1%
4202	1	< 0.1%
4201	1	< 0.1%
4200	1	< 0.1%
4199	1	< 0.1%
4198	1	< 0.1%
4197	1	< 0.1%
4196	1	< 0.1%
4195	2	< 0.1%
4194	1	< 0.1%

transaction_date
Date

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	389.9 KiB

Minimum	2019-04-01 00:00:00
Maximum	2019-04-29 00:00:00

Histogram

Histogram with fixed size bins (bins=29)

transaction_time
Date

Distinct	26074
Distinct (%)	52.3%
Missing	0
Missing (%)	0.0%
Memory size	389.9 KiB

Minimum	2023-08-02 01:00:44
Maximum	2023-08-02 20:59:32

Histogram

Histogram with fixed size bins (bins=50)

sales_outlet_id
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	389.9 KiB

8	17071
3	16829
5	15994

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49894
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	3
5th row	3

Common Values

Value	Count	Frequency (%)
8	17071	34.2%
3	16829	33.7%
5	15994	32.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
8	17071	34.2%
3	16829	33.7%
5	15994	32.1%

Most occurring characters

Value	Count	Frequency (%)
8	17071	34.2%
3	16829	33.7%
5	15994	32.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	49894	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	17071	34.2%
3	16829	33.7%
5	15994	32.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	49894	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	17071	34.2%
3	16829	33.7%
5	15994	32.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49894	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	17071	34.2%
3	16829	33.7%
5	15994	32.1%

staff_id
Real number (ℝ)

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.359582

Minimum	6
Maximum	45
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	15
median	26
Q3	41
95-th percentile	45
Maximum	45
Range	39
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	12.46649
Coefficient of variation (CV)	0.49158894
Kurtosis	-1.2641419
Mean	25.359582
Median Absolute Deviation (MAD)	12
Skewness	0.34018302
Sum	1265291
Variance	155.41338
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
12	5930	11.9%
42	4085	8.2%
45	3648	7.3%
26	3629	7.3%
16	3198	6.4%
20	3127	6.3%
17	3059	6.1%
14	2770	5.6%
30	2430	4.9%
44	2349	4.7%
Other values (15)	15669	31.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	1629	3.3%
7	633	1.3%
8	306	0.6%
9	380	0.8%
10	194	0.4%
12	5930	11.9%
13	90	0.2%
14	2770	5.6%
15	2034	4.1%
16	3198	6.4%

Value	Count	Frequency (%)
45	3648	7.3%
44	2349	4.7%
43	2140	4.3%
42	4085	8.2%
41	1204	2.4%
30	2430	4.9%
29	2112	4.2%
28	1751	3.5%
27	2063	4.1%
26	3629	7.3%

customer_id
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2248
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2282.3245

Minimum	0
Maximum	8501
Zeros	25033
Zeros (%)	50.2%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5412
95-th percentile	8342
Maximum	8501
Range	8501
Interquartile range (IQR)	5412

Descriptive statistics

Standard deviation	3240.5518
Coefficient of variation (CV)	1.4198471
Kurtosis	-0.90040729
Mean	2282.3245
Median Absolute Deviation (MAD)	0
Skewness	0.92450401
Sum	1.138743 × 10⁸
Variance	10501176
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25033	50.2%
3	31	0.1%
548	31	0.1%
8285	31	0.1%
8341	29	0.1%
8009	28	0.1%
8118	28	0.1%
8036	28	0.1%
8158	28	0.1%
8101	27	0.1%
Other values (2238)	24600	49.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25033	50.2%
1	8	< 0.1%
2	21	< 0.1%
3	31	0.1%
4	9	< 0.1%
5	6	< 0.1%
6	12	< 0.1%
7	11	< 0.1%
8	13	< 0.1%
9	12	< 0.1%

Value	Count	Frequency (%)
8501	6	< 0.1%
8500	21	< 0.1%
8499	12	< 0.1%
8498	9	< 0.1%
8497	12	< 0.1%
8496	14	< 0.1%
8495	17	< 0.1%
8494	18	< 0.1%
8493	16	< 0.1%
8492	21	< 0.1%

instore_yn
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	389.9 KiB

Y	24992
N	24608
	294

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49894
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	Y
4th row	N
5th row	Y

Common Values

Value	Count	Frequency (%)
Y	24992	50.1%
N	24608	49.3%
	294	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
y	24992	50.4%
n	24608	49.6%

Most occurring characters

Value	Count	Frequency (%)
Y	24992	50.1%
N	24608	49.3%
	294	0.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49600	99.4%
Space Separator	294	0.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
Y	24992	50.4%
N	24608	49.6%

Space Separator

Value	Count	Frequency (%)
	294	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49600	99.4%
Common	294	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
Y	24992	50.4%
N	24608	49.6%

Common

Value	Count	Frequency (%)
	294	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49894	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
Y	24992	50.1%
N	24608	49.3%
	294	0.6%

order
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1734277

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0254447
Coefficient of variation (CV)	0.87388832
Kurtosis	35.05642
Mean	1.1734277
Median Absolute Deviation (MAD)	0
Skewness	5.9891027
Sum	58547
Variance	1.0515369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	48387	97.0%
7	916	1.8%
9	253	0.5%
6	132	0.3%
2	83	0.2%
5	61	0.1%
3	56	0.1%
8	4	< 0.1%
4	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	48387	97.0%
2	83	0.2%
3	56	0.1%
4	2	< 0.1%
5	61	0.1%
6	132	0.3%
7	916	1.8%
8	4	< 0.1%
9	253	0.5%

Value	Count	Frequency (%)
9	253	0.5%
8	4	< 0.1%
7	916	1.8%
6	132	0.3%
5	61	0.1%
4	2	< 0.1%
3	56	0.1%
2	83	0.2%
1	48387	97.0%

line_item_id
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6318595

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	5
Maximum	12
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4128807
Coefficient of variation (CV)	0.86581024
Kurtosis	2.6969449
Mean	1.6318595
Median Absolute Deviation (MAD)	0
Skewness	2.0433121
Sum	81420
Variance	1.9962319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	39949	80.1%
5	6332	12.7%
2	2547	5.1%
3	503	1.0%
6	324	0.6%
4	177	0.4%
9	55	0.1%
8	4	< 0.1%
12	1	< 0.1%
10	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	39949	80.1%
2	2547	5.1%
3	503	1.0%
4	177	0.4%
5	6332	12.7%
6	324	0.6%
7	1	< 0.1%
8	4	< 0.1%
9	55	0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
10	1	< 0.1%
9	55	0.1%
8	4	< 0.1%
7	1	< 0.1%
6	324	0.6%
5	6332	12.7%
4	177	0.4%
3	503	1.0%
2	2547	5.1%

product_id
Real number (ℝ)

Distinct	80
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.878983

Minimum	1
Maximum	87
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	1
5-th percentile	23
Q1	33
median	47
Q3	60
95-th percentile	78
Maximum	87
Range	86
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	17.928355
Coefficient of variation (CV)	0.37445146
Kurtosis	-0.67144817
Mean	47.878983
Median Absolute Deviation (MAD)	13
Skewness	0.19720739
Sum	2388874
Variance	321.42592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
71	1034	2.1%
50	1015	2.0%
59	1000	2.0%
61	995	2.0%
38	993	2.0%
29	991	2.0%
52	985	2.0%
54	984	2.0%
26	978	2.0%
32	978	2.0%
Other values (70)	39941	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	69	0.1%
2	65	0.1%
3	53	0.1%
4	47	0.1%
5	50	0.1%
6	70	0.1%
7	51	0.1%
8	67	0.1%
9	67	0.1%
10	48	0.1%

Value	Count	Frequency (%)
87	755	1.5%
84	569	1.1%
83	97	0.2%
82	69	0.1%
81	79	0.2%
79	677	1.4%
78	639	1.3%
77	611	1.2%
76	622	1.2%
75	645	1.3%

quantity
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.438209

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	2
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5430387
Coefficient of variation (CV)	0.37757983
Kurtosis	1.0970904
Mean	1.438209
Median Absolute Deviation (MAD)	0
Skewness	0.82201515
Sum	71758
Variance	0.29489103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	29170	58.5%
2	19616	39.3%
3	1094	2.2%
4	9	< 0.1%
8	4	< 0.1%
6	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	29170	58.5%
2	19616	39.3%
3	1094	2.2%
4	9	< 0.1%
6	1	< 0.1%
8	4	< 0.1%

Value	Count	Frequency (%)
8	4	< 0.1%
6	1	< 0.1%
4	9	< 0.1%
3	1094	2.2%
2	19616	39.3%
1	29170	58.5%

line_item_amount
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	77
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.6826462

Minimum	0
Maximum	360
Zeros	24
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3.75
Q3	6
95-th percentile	9
Maximum	360
Range	360
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	4.4366683
Coefficient of variation (CV)	0.94747031
Kurtosis	3308.2068
Mean	4.6826462
Median Absolute Deviation (MAD)	1.25
Skewness	42.895845
Sum	233635.95
Variance	19.684025
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	5916	11.9%
6	5149	10.3%
2.5	4376	8.8%
5	4120	8.3%
3.75	4109	8.2%
3.5	3184	6.4%
7.5	2119	4.2%
3.25	1992	4.0%
4	1384	2.8%
7	1357	2.7%
Other values (67)	16188	32.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	24	< 0.1%
0.8	1080	2.2%
1	156	0.3%
1.6	1130	2.3%
2	929	1.9%
2.1	184	0.4%
2.2	913	1.8%
2.4	31	0.1%
2.45	435	0.9%
2.5	4376	8.8%

Value	Count	Frequency (%)
360	4	< 0.1%
72	1	< 0.1%
56	1	< 0.1%
45	63	0.1%
36	1	< 0.1%
28	84	0.2%
24	1	< 0.1%
23	12	< 0.1%
22.5	55	0.1%
21	70	0.1%

unit_price
Real number (ℝ)

Distinct	41
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3846454

Minimum	0.8
Maximum	45
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.9 KiB

Quantile statistics

Minimum	0.8
5-th percentile	2
Q1	2.5
median	3
Q3	3.75
95-th percentile	4.5
Maximum	45
Range	44.2
Interquartile range (IQR)	1.25

Descriptive statistics

Standard deviation	2.6825447
Coefficient of variation (CV)	0.79256299
Kurtosis	99.83137
Mean	3.3846454
Median Absolute Deviation (MAD)	0.5
Skewness	8.5307304
Sum	168873.5
Variance	7.1960461
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
3	11316	22.7%
2.5	8762	17.6%
3.75	6214	12.5%
3.5	4609	9.2%
0.8	2248	4.5%
3.25	2023	4.1%
2.2	1904	3.8%
4.25	1903	3.8%
2	1877	3.8%
3.1	1862	3.7%
Other values (31)	7176	14.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.8	2248	4.5%
2	1877	3.8%
2.1	256	0.5%
2.2	1904	3.8%
2.45	883	1.8%
2.5	8762	17.6%
2.55	907	1.8%
2.65	96	0.2%
3	11316	22.7%
3.1	1862	3.7%

Value	Count	Frequency (%)
45	67	0.1%
28	83	0.2%
23	12	< 0.1%
22.5	55	0.1%
21	70	0.1%
20.45	47	0.1%
19.75	51	0.1%
18	134	0.3%
15	50	0.1%
14.75	53	0.1%

promo_item_yn
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

False	49404
True	490

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	49404	99.0%
True	490	1.0%

Auto

Heatmap
Table

	transaction_id	staff_id	customer_id	order	line_item_id	product_id	quantity	line_item_amount	unit_price	sales_outlet_id	instore_yn	promo_item_yn
transaction_id	1.000	0.002	0.042	-0.061	-0.071	-0.043	0.021	0.021	-0.007	0.202	0.048	0.036
staff_id	0.002	1.000	0.112	0.007	0.001	0.009	0.011	0.001	-0.011	0.860	0.129	0.073
customer_id	0.042	0.112	1.000	-0.034	-0.030	-0.012	0.009	0.012	-0.001	0.609	0.025	0.015
order	-0.061	0.007	-0.034	1.000	-0.020	-0.154	-0.141	0.245	0.274	0.063	0.005	0.012
line_item_id	-0.071	0.001	-0.030	-0.020	1.000	0.628	-0.301	-0.254	0.123	0.081	0.135	0.235
product_id	-0.043	0.009	-0.012	-0.154	0.628	1.000	-0.175	-0.126	0.216	0.064	0.008	0.261
quantity	0.021	0.011	0.009	-0.141	-0.301	-0.175	1.000	0.682	-0.159	0.155	0.008	0.035
line_item_amount	0.021	0.001	0.012	0.245	-0.254	-0.126	0.682	1.000	0.522	0.007	0.000	0.000
unit_price	-0.007	-0.011	-0.001	0.274	0.123	0.216	-0.159	0.522	1.000	0.027	0.012	0.012
sales_outlet_id	0.202	0.860	0.609	0.063	0.081	0.064	0.155	0.007	0.027	1.000	0.075	0.077
instore_yn	0.048	0.129	0.025	0.005	0.135	0.008	0.008	0.000	0.012	0.075	1.000	0.004
promo_item_yn	0.036	0.073	0.015	0.012	0.235	0.261	0.035	0.000	0.012	0.077	0.004	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	transaction_id	transaction_date	transaction_time	sales_outlet_id	staff_id	customer_id	instore_yn	order	line_item_id	product_id	quantity	line_item_amount	unit_price	promo_item_yn
0	7	2019-04-01	2023-08-02 12:04:43	3	12	558	N	1	1	52	1	2.50	2.50	N
1	11	2019-04-01	2023-08-02 15:54:39	3	17	781	N	1	1	27	2	7.00	3.50	N
2	19	2019-04-01	2023-08-02 14:34:59	3	17	788	Y	1	1	46	2	5.00	2.50	N
3	32	2019-04-01	2023-08-02 16:06:04	3	12	683	N	1	1	23	2	5.00	2.50	N
4	33	2019-04-01	2023-08-02 19:18:37	3	17	99	Y	1	1	34	1	2.45	2.45	N
5	39	2019-04-01	2023-08-02 18:54:46	3	17	664	Y	1	1	32	1	3.00	3.00	N
6	50	2019-04-01	2023-08-02 13:03:49	3	12	316	N	1	1	49	2	6.00	3.00	N
7	53	2019-04-01	2023-08-02 11:21:14	3	12	38	N	1	1	60	1	3.75	3.75	N
8	59	2019-04-01	2023-08-02 19:30:55	3	12	370	Y	1	1	51	2	6.00	3.00	N
9	62	2019-04-01	2023-08-02 12:01:00	3	12	180	Y	1	1	49	2	6.00	3.00	N

	transaction_id	transaction_date	transaction_time	sales_outlet_id	staff_id	customer_id	instore_yn	order	line_item_id	product_id	quantity	line_item_amount	unit_price	promo_item_yn
49884	742	2019-04-29	2023-08-02 19:23:25	8	45	0	N	1	5	74	1	3.50	3.50	N
49885	746	2019-04-29	2023-08-02 15:54:11	8	15	0	N	1	1	37	2	6.00	3.00	N
49886	746	2019-04-29	2023-08-02 15:54:11	8	15	0	N	1	5	71	1	3.75	3.75	N
49887	749	2019-04-29	2023-08-02 19:34:50	8	15	0	N	1	1	47	1	3.00	3.00	N
49888	752	2019-04-29	2023-08-02 16:36:24	8	42	8401	N	1	1	87	1	2.10	2.10	Y
49889	753	2019-04-29	2023-08-02 16:51:58	8	42	0	N	1	1	30	1	3.00	3.00	N
49890	756	2019-04-29	2023-08-02 16:51:14	8	42	8412	Y	1	1	25	2	4.40	2.20	N
49891	759	2019-04-29	2023-08-02 11:17:36	8	15	0	Y	1	1	31	1	2.20	2.20	N
49892	763	2019-04-29	2023-08-02 15:45:52	8	45	8030	N	1	1	44	2	5.00	2.50	N
49893	763	2019-04-29	2023-08-02 15:45:52	8	45	8030	N	1	5	75	1	3.50	3.50	N

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample